package com.admin.service.borservice;

import com.borrower.dto.BorrowInfoBean;
import com.pojo.BorrowerBean;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface BorService {


    List<BorrowerBean> getBorInfo(BorrowerBean bor);

    boolean updateBorBalance(BorrowerBean bor);
    List<BorrowerBean> getAllBorInfo ();

    List<BorrowerBean> getBorInfoByName (BorrowerBean bor);

    boolean getIdCardBookNameAddFreeAndTime(String idCard, String bookName, double renewalFree, String renewalTime);
    BorrowerBean getBorInfoByIdCard(BorrowerBean bor);




    /**
     * 借阅信息表的总金额
     */
    Double borinfoSum();

    Double booksInfoSum();



    /**
     * 获得用户注销消息
     * @return
     */
    List<BorrowerBean> getBorCancelInfo(BorrowerBean bor);

    /**
     * 修改用户注销状态
     * @return
     */
    boolean updateBorCancel(BorrowerBean bor);


    /**
     * 显示所有用户借书信息
     * @param bor
     * @return
     */
    List<BorrowInfoBean> getBorrowInfoService(BorrowInfoBean bor);
}


